<%@ page import="java.sql.*, studentportal.*"%>
<%@taglib uri="http://java.sun.com/jstl/core" prefix="c"%>
<html>

<body background="indtextb.jpg" bgcolor="#FFFFFF" text="#000000" link="#3366CC" vlink="#666666" alink="#996600">

<table border="0" width="100%" bordercolorlight="#666666" bordercolordark="#000000">
  <tr>
    <td width="100%"><img border="0" src="StdPrtlbanner.jpg" width="846" height="65">&nbsp;</td>
  </tr>
</table>
<table border="0" align="center" width="100%" bordercolorlight="#666666" bordercolordark="#000000">
  <tr>
    <td width="10%">
      <a href="Student_Persanal_InfoView.jsp">Personal Info</a></td>
    <td width="10%">
      <a href="Student_Course_InfoView.jsp">Course Info</a></td>
    <td width="10%">
      <a href="Student_Notes_InfoView.jsp">Notes Info</a></td>
    <td width="10%">
      <a href="Student_Assignment_InfoView.jsp">Assignment Info</a></td>
    <td width="10%">
      <a href="Student_Book.jsp">Books</a></td>
    <td width="10%">
      <a href="Student_Notification.jsp">Notifications</a></td>
    <td width="10%">
      <a href="Student_Security_InfoView.jsp">Security</a></td>
    <td width="10%">
      <a href="Home.html">Home</a></td>
  </tr>
</table>
<%
					
					Connection con=MySQLDriver.getConnection(); 
					Statement st=con.createStatement();
					System.out.println("After Statement");
					String sid=(String)session.getAttribute("StudentId");
					System.out.println("STRING"+sid);
					String str="select student_id, student_name, student_address, student_dob, student_phone, student_email, student_admt_date, student_login_name, student_login_status,(select course_master.course_name from course_master where course_master.course_id = student_master.course_id) from student_master where student_id='"+sid+"'";
					ResultSet rs=st.executeQuery(str);
					rs.next();
					//Student stu=(Student)session.getAttribute("Student");
%>
<p align="center">&nbsp;</p>
<form method="POST" action="./StudentRegServlet">
 
  <div align="center">
    <center>
    <table border="1" width="68%" bordercolor="#0000FF">
      <tr>
        <td width="100%" colspan="2">
          <p align="center"><b><font size="4" color="#008000">Student Personal Information</font></b></td>
      </tr>
    </center>
    <tr>
      <td width="50%" valign="middle" align="left">
        <p align="left">Student No</td>
      <center>
      <td width="50%"><input type="text" name="sid" size="20" tabindex="1" value="<%=rs.getString(1)%>" disabled="true"></td>	
      </tr>
    </center>
    <tr>
      <td width="50%" valign="middle" align="left">
        <p align="left">Name</td>
      <center>
      <td width="50%"><input type="text" name="sname" size="20" tabindex="2" value="<%=rs.getString(2)%>" disabled="true"></td>
      </tr>
      <tr>
        <td width="50%" valign="middle" align="left">Address</td>
        <td width="50%"><textarea rows="2" name="sadd" cols="20" tabindex="3" disabled="true"><%=rs.getString(3)%></textarea></td>
      </tr>
      <tr>
        <td width="50%" valign="middle" align="left">Date of Birth</td>
        <td width="50%"><input type="text" name="sdob" size="20" tabindex="4" value="<%=rs.getDate(4)%>" disabled="true"></td>
      </tr>
      <tr>
        <td width="50%" valign="middle" align="left">Phone Number</td>
        <td width="50%"><input type="text" name="sphone" size="20" tabindex="5" value="<%=rs.getString(5)%>" disabled="true"></td>
      </tr>
      <tr>
        <td width="50%" valign="middle" align="left">Email ID</td>
        <td width="50%"><input type="text" name="semail" size="20" tabindex="6" value="<%=rs.getString(6)%>" disabled="true"></td>
      </tr>
      <tr>
        <td width="50%" valign="middle" align="left">Admission Date</td>
        <td width="50%"><input type="text" name="sdoa" size="20" tabindex="7" value="<%=rs.getDate(7)%>" disabled="true"></td>
      </tr>
      <tr>
        <td width="50%" valign="middle" align="left">Login Name</td>
        <td width="50%"><input type="text" name="slogin" size="20" tabindex="8" value="<%=rs.getString(8)%>" disabled="true"></td>
      </tr>
	  <tr>
        <td width="50%" valign="middle" align="left">Course Name</td>
        <td width="50%"><input type="text" name="slogin" size="20" tabindex="8" value="<%=rs.getString(10)%>" disabled="true"></td>
      </tr>
    </table>
    </center>
  </div>
</form>
<p align="left">&nbsp;</p>
<%con.close();%>

</body>

</html>
